
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sp_MonHoc_InsertMonHoc]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop procedure [dbo].[sp_MonHoc_InsertMonHoc]
GO
create procedure sp_MonHoc_InsertMonHoc
	@MaMH varchar(10),
	@Ten_MH nvarchar(100),
	@Thoi_Gian_Bat_Dau datetime,
	@Thoi_Gian_Ket_Thuc datetime,
	@Chung_Chi varchar(40),
	@Le_Phi varchar(40)	
as
begin			
	INSERT INTO MonHoc
		(
			MaMH,
			Ten_MH,		
			Thoi_Gian_Bat_Dau,	
			Thoi_Gian_Ket_Thuc,
			Chung_Chi,
			Le_Phi
		)	
	VALUES	
		(
			@MaMH,
			@Ten_MH,
			@Thoi_Gian_Bat_Dau,	
			@Thoi_Gian_ket_Thuc,		
			@Chung_Chi,
			@Le_Phi
		)
end



